USE [BMIG_Mensual_POST_CADENA]
GO

/****** Object:  StoredProcedure [dbo].[WASP_M0003_CREATB_PRIMA_COMISION]    Script Date: 11/28/2011 12:21:31 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WASP_M0003_CREATB_PRIMA_COMISION]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[WASP_M0003_CREATB_PRIMA_COMISION]
GO

USE [BMIG_Mensual_POST_CADENA]
GO

/****** Object:  StoredProcedure [dbo].[WASP_M0003_CREATB_PRIMA_COMISION]    Script Date: 11/28/2011 12:21:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[WASP_M0003_CREATB_PRIMA_COMISION] --en dts el job se llama DROP/CREATE
AS
begin

		if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[prima_comision]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		drop table [dbo].[prima_comision]
end
		

GO

